Title of the Workshop
The tittle of the workshop is ‘One Day Workshop on Microsoft Excel – Basic’
Overview
This workshop is designed to give a solid foundation in the Microsoft Excel. This is a fully-fledged practical workshop complies with Microsoft Excel 2016. This workshop lessons help to: use math, statistical, logic and text functions; organise data sorting and filtering; effectively present the data in several chart formats; find a value with VLOOKUP; create and format Pivot Tables; record basic Macros, and Data; and optimisation, analysis, transformation, and validation. Sharpening these skills on will assists the participants in improving their study and/or work productivity and accuracy. At the end of the workshop, Microsoft Excel will no longer just be a skill in the participant’ s curriculum vitae but a value addition to their professional life.
In completion a ‘Participation Certificate’ will be awarded IT Centre, Vavuniya Campus of the University of Jaffna.
Target Group
This workshop is designed for school students in age 15 or above, school leavers from GCE Ordinary Level as well as GCE Advanced Level, students from undergraduates as well as postgraduates, business professionals, and workers from government and non-organisation.
Duration and Schedule
One day workshop, 8 Hours on Saturday – 9am to 5pm
Fee Per Participant
Rs 2750 for Students and Rs 3500 for workers/ staff
Medium of Instruction
This workshop is conducted in bilingual languages including English and Tamil. Participants can use both English and/or Tamil in the lecture discussions.
Method of Teaching and Learning
The workshop will be delivered in a combination of lectures, computer laboratory practical sessions, and group works.
Objectives of the workshop
The objective of the workshop is:
- To provide the basic knowledge of spreadsheet concepts.
- To provide the practical skill in using the Microsoft Excel 2016 software.
- To produce capable personnel in office applications, to the present job market.
Learning outcomes
- Indicate the names and functions of the Excel interface components.
- Enter and edit data.
- Format data and cells.
- Construct formulas, including the use of built-in functions, and relative and absolute
references. - Create and modify charts.
- Preview and print worksheets.
- Use the Excel online Help feature.
- Use essential formula, including Dates and Time.
- Use advance formulas, including the use of Formula Auditing, Temporal Functions, and
VLOOKUP. - Use data: optimisation, analysis, transformation, and validation.
- Use data visualization.